Export Data dialog box

Use the Export Data dialog box to select the options you want to use when exporting model data to a linked Excel file. For more information, see Setting up export links

To open the Export Data Dialog box, choose Export Data from the Edit menu.

Export Type

Use the options in this section to select the type of export link you want to create.

• One Time – Select this option to export the initial values for the model once. Data from the model will be exported to the Excel file when you click OK in the Export Data dialog box, and will not be exported again.
• Persistent – Select this option to export data now and to use the established link to manually or automatically export data in the future. If you select this option, choose how you want to export data via the persistent link:
• On Demand – Select this option to export data only when you choose to export it. Data from the Excel file will be exported when you first create the link and, thereafter, only when you click the Export Nowbutton in the Manage Persistent Links dialog box.
• Dynamic – Select this option to export data automatically when a model runs.

Export Data Source

Use the options in this section to select which data you want to export and how often.

• Export all model variables – Select this option to export all variables (entities) in the model to the Excel file.

  Note: You can create only one export link that has this option selected.

• Export variables in table – Select this option to export only the variables (entities) specified in a table, in the order in which they appear in the table. If you select this option, you must choose the table that contains the variables (entities) you want to export.

  Note: You can create only one export link per model table. If you have already created an export link for a table, that table is not available for other another export link unless you delete the existing export link for that table.

• Interval – Select how often you want to export the selected variables (entities):
• One set of values – Select this option to export the values as they are in the model right now. The Excel worksheet will be formatted so that the data can be imported back into the model later.
• Every ___ <unit of time> – Select this option to export the values in the model after an interval in relation to the model's DT. When you select this option, enter the interval value in the box. For example, if the model's time unit is Months, you can export a value for every other Month by entering 2 in the box.
• Every DT - Export every intermediate value during the run – Select this option to export the values in the model for every DT in the next simulation run.

• Use table settings – Select this option to export the values exactly as they appear in the table whose values you are exporting. The exported values will use the report interval, orientation, and other settings as specified in the Define Table dialog box for the table.

  Note: The Use table settings option is available only if you selected the Export variables in table option.

Export Destination

Use the options in this section to specify the Excel file to which you will export the data and the orientation of the data in the export worksheet.

• Excel File Name – Click the Browse button to navigate to and select the Excel file to which you will export the data.
• Worksheet Name – Select the worksheet in the specified Excel file to which you want to export the data. This option appears only after you have selected an Excel file.

• Data – Select the option next to the image that shows the data format used in the selected worksheet:

  Note: If you selected the Use table settings under "Export Data Source", the Data option is disabled. The exported table will use the orientation specified in the table's Define Table dialog box.

• If the variable (entity) names are specified as column headings in the Excel worksheet, select the left-most option:

  

• If the variable (entity) names are specified as row headings in the Excel worksheet, select the right-most option: